Linked Cube Views

Linked cube views provide the option to launch a cube view from another when viewing it in the Data Explorer grid, spreadsheet tool, or Excel Add-In. You can right-click a cube view's data cell and open a separate cube view to access more detail and visibility. This applies to any cube view, such as those for data entry forms. See:

• Create a sample linked cube view

• Link a cube view to another entire cube view

• Link a cube view to specific rows or columns

• Nest linked cube views

TIP: For information about evaluating source cube view data in a linked cube view using passed point of view selections, see Analyze data with passed point of view selections.

NOTE: For Linked Cube Views, the Workspace Name will not be automatically prefixed. The search order of operations (requested workspace, current workspace, default workspace, and then shared workspaces) will be used to find the correct Cube View.

Create a Sample Linked Cube View

The following describes how to create a sample linked cube view. In this example, an Income Statement Summary cube view has an Account Detail cube view assigned to all data cells and a Sales by Product cube view linked to specific rows. You can also add a second level of linked cube views for an even more granular analysis.

Link a Cube View to an Entire Cube View

1. Select the cube view to be linked and apply to the entire cube view, specific columns, or specific rows. If the linked cube view applies to the entire cube view, you can right-click any data cell in the Data Explorer grid, spreadsheet tool, or Excel Add-In to access the cube view. If it only applies to columns or rows, the linked cube view is available when you right-click on a data cell in that row or column.
   

NOTE: Column settings override cube view settings and row settings override column settings.

2. Once the base cube view is determined, in this example IncomeStatementSummary, create a cube view that will display more detailed data.
   
   The AccountDetail cube view will display Account details based on the selected data cell. The IncomeStatementSummary’s data displays Parent accounts for a specific time, so the AccountDetail’s data will display the selected Account’s children for that same time period.

3. In the AccountDetail cube view, configure the columns and rows to query the correct data.
   
   |!DrillAccount!| is a Bound parameter and will display the correct account data based on the selected account in the IncomeStatementSummary cube view.
   
   !DrillTime!| is a Bound parameter and will display the correct Time data based on the selected time in the IncomeStatementSummary cube view

4. Ensure the AccountDetail’s POV matches the IncomeStatementSummary’s POV with the exception of Account and Time. Enter the |!DrillAccount!| and |!DrillTime!| parameters into these member fields to ensure that the AccountDetail cube view displays data based on the selected Account and Time in the IncomeStatementSummary.

5. Add any required formatting to the AccountDetail cube view. In this example, the following was added to Page Caption:
   

6. To assign the AccountDetail to the entire IncomeStatementSummary cube view, select IncomeStatementSummary and click General > Navigation Links . Enter the names of the linked cube view in Linked Cube Views or click the ellipsis to find the cube view using Object Lookup.

7. Enter the Bound parameters which will pass from one cube view to the next. In this example, a Bound parameter was entered for Account and Time so both members are based on the selected IncomeStatementSummary data cell.
   

Run IncomeStatementSummary, noting that you can right-click cells to access the AccountDetail cube view.

Link a Cube View to Specific Rows or Columns

This topic describes how to assign a linked cube view to specific rows. The ProductDetail cube view will display product details based on the IncomeStatmentSummary’s selected data cell. The IncomeStatementSummary’s data displays parent accounts for a specific time, so the ProductDetail’s data displays the selected account’s product sales.

In the ProductDetail cube, configure the rows/columns, POV, and formatting to ensure that the user sees the correct data. See the AccountDetail instructions above for details.

To assign the ProductDetail cube view to IncomeStatementSummary rows, select the IncomeStatementSummary cube view, then go to the Linked Cube Views property on the Data tab in the Rows/Columns. Select the row or column and enter the name of the cube view.

NOTE: Due to overrides, assign the AccountDetail cube view to this property too. Previously, AccountDetail was assigned to the entire cube view. However, because a cube view is being assigned to a row, the cube view settings are overridden and only display the cube view specified for this property. For both cube views to be available on the row, specify them both.

If any Bound parameters need to be entered (in this example, the same Bound parameters are used for both cube views), enter them under Navigation Links in General Settings.

In the example above, the ProductDetail Cube View was assigned to the Net Sales row. When a user right-clicks on a Net Sales cell in the Data Explorer grid, Spreadsheet tool, or Excel Add-In, this cube view is available.

Nest Linked Cube Views

You can link a cube views to cube views that are already linked. In this example, the ProductDetail_2 cube view is linked to ProductDetail and displays specific product data tied to a selected ProductDetail cell.

1. In ProductDetail_2, configure the rows and columns as needed.
   
   

2. Enter a |!DrillProduct!| Bound parameter to display specific product details. For example, if you right-click a Clubs cell in the ProductDetail cube view and select the ProductDetail_2, sales details for Clubs displays.
   

3. Ensure a |!DrillTime!| parameter is also used.

4. Set the POV for ProductDetail_2 so it matches the ProductDetail POV, except for the User Defined 2 member. In this example, products are viewed using the UD2 member. Enter |!DrillProduct!| in User Defined 2.

5. Add any required formatting to the ProductDetail_2, such as page captioning:
   

6. Open ProductDetail and navigate to Linked Cube View under General Settings > Navigation Links.

7. Click the ellipsis and select the ProductDetail_2 cube view. This link the cube view to the entire ProductDetail cube view.

8. Enter the Bound parameter from ProductDetail_2.
   

9. Run ProductDetail from IncomeStatementSummary, right-click cells and select Navigate To ProductDetail_2.